| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I see/edit my Private macros i VB?
Hi
Can someone please tell me how I can see/edit the VB code for all the macros in my Excel worksheet that I had made Private by adding "Private" to the start of the sub? As they do not appear in the emacro list anymore, I can't select and edit them. So basically, how do I "unPrivate" the macros back to their normal visible state?? Cheers Ace70 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I see/edit my Private macros i VB?
Go into the VBIDE (Alt-F11), select the module and change them.
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Ace70" wrote in message oups.com... Hi Can someone please tell me how I can see/edit the VB code for all the macros in my Excel worksheet that I had made Private by adding "Private" to the start of the sub? As they do not appear in the emacro list anymore, I can't select and edit them. So basically, how do I "unPrivate" the macros back to their normal visible state?? Cheers Ace70 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Private Sub Workbook_Open() doesn't run | Excel Discussion (Misc queries) | |||
| Private Sub CommandButton1_Click() | Excel Discussion (Misc queries) | |||
| Excel 2007 Beta - can't edit macros | Excel Discussion (Misc queries) | |||
| Private sub | New Users to Excel | |||
| how can i edit excel 4 macros in Excel 2003 | Excel Worksheet Functions | |||
Hybrid Mode
