Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert VBA code user a macro
Hi, I was wondering if it is possible to add the VBA code below in one of the Microsoft Excel Objects called "Sheet2 (Begroting Calc Won)" in the VB editor by using a macro. How should the VBA code look like? Thanks in advance! Code: -------------------- Private Sub Worksheet_Activate() Dim oCB As CommandBar Set oCB = CommandBars("Verticaal Transport") oCB.Controls("Projectgegevens Aanpassen").Enabled = True oCB.Controls("Gegevens Aanpassen").Enabled = True oCB.Controls("Rij Invoegen").Enabled = True oCB.Controls("Rij Verwijderen").Enabled = True End Sub -------------------- -- leonidas ------------------------------------------------------------------------ leonidas's Profile: http://www.excelforum.com/member.php...o&userid=35375 View this thread: http://www.excelforum.com/showthread...hreadid=559233 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert VBA code user a macro
See http://www.cpearson.com/excel/vbe.htm
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "leonidas" wrote in message ... Hi, I was wondering if it is possible to add the VBA code below in one of the Microsoft Excel Objects called "Sheet2 (Begroting Calc Won)" in the VB editor by using a macro. How should the VBA code look like? Thanks in advance! Code: -------------------- Private Sub Worksheet_Activate() Dim oCB As CommandBar Set oCB = CommandBars("Verticaal Transport") oCB.Controls("Projectgegevens Aanpassen").Enabled = True oCB.Controls("Gegevens Aanpassen").Enabled = True oCB.Controls("Rij Invoegen").Enabled = True oCB.Controls("Rij Verwijderen").Enabled = True End Sub -------------------- -- leonidas ------------------------------------------------------------------------ leonidas's Profile: http://www.excelforum.com/member.php...o&userid=35375 View this thread: http://www.excelforum.com/showthread...hreadid=559233 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula, Macro, or VBA code to find and insert | Excel Worksheet Functions | |||
Macro code to test for blank row and insert blank row if false | Excel Programming | |||
user input into active excel macro- prompt - respond -insert-cont | Excel Programming | |||
Insert VBA code with a macro in a .xls file by workbook open event | Excel Programming | |||
insert data into macro code from text input field? | Excel Programming |