Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Marco worksheet
HiI have created a few macros using VBA in excel.
I now want to use a macro worksheet instead, since it seems easier to find your macros. This is totaly new to me and I am a little lost. I have created a macro worksheet in my workbook. Now I want to create a macro that will hide and show tabs in my workbook. This is the code a used in VBA Sub UnhideSheet() Sheets("Read Me").Visible = True End Sub Sub HideSheet() Sheets("Read Me").Visible = False End Sub How do I create this code in a macro worksheet? How do I assign it to an object? It seems when I do an assign only my VBA macros appear. What are the benifts of using either VBA code or Macro worksheet? Is there a record method like in VBA so I can work from thoses results? And is there a beginner lesson somewhere I can learn this method? Thanks in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Marco worksheet
A macro worksheet only supports the old Excel 4 Macro language. You can not
use VBA in a macro sheet. -- Regards, Tom Ogilvy "sal" wrote in message om... HiI have created a few macros using VBA in excel. I now want to use a macro worksheet instead, since it seems easier to find your macros. This is totaly new to me and I am a little lost. I have created a macro worksheet in my workbook. Now I want to create a macro that will hide and show tabs in my workbook. This is the code a used in VBA Sub UnhideSheet() Sheets("Read Me").Visible = True End Sub Sub HideSheet() Sheets("Read Me").Visible = False End Sub How do I create this code in a macro worksheet? How do I assign it to an object? It seems when I do an assign only my VBA macros appear. What are the benifts of using either VBA code or Macro worksheet? Is there a record method like in VBA so I can work from thoses results? And is there a beginner lesson somewhere I can learn this method? Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Marco Help | Excel Discussion (Misc queries) | |||
I need some help with a Marco | Excel Discussion (Misc queries) | |||
Marco | New Users to Excel | |||
Can it be done by marco? | Excel Programming | |||
marco | Excel Programming |