Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello Newsgroup,
I have got an Excelsheet wich was created from my predecessor. My task is to change some details in macros and userforms. But I cannot find not one line of code! The workbook consists of six sheets with commandbuttons. (No hidden sheets) On a button click a form will appear with combo/command/textbox/checkbox/... controls. The input of the controls will be filled in the sheet. But the surprising thing was that in the VB editor were not one userforme or modul nor one line of code! Behind the sheets are also no code. In the project window is only the workbook opened. Also are no AddIns loaded. If I make a right click on the command button of the sheet I got the information that the button is connect with a macro called MainSheet_TaxEntry. But if I go to the VB Editor I cant use this macro. I got the message that MainSheet_TaxEntry is not defined. I have placed the Excelsheet on my private computer. All forms and macros are still available! So, where are the macros and userforms? Best wishes Peter PS: I m not a beginning user. I have ask this questions in some "normal" VB usergroups but noone could help me. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Problem is solved. The hidden macros are from Excel 4.0.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macros with hidden sheets! | Excel Programming | |||
Unhide Worksheets (hidden via macros) | Excel Discussion (Misc queries) | |||
excel macros truncating tabs for hidden columns. | Excel Discussion (Misc queries) | |||
running macros on hidden sheets? | Excel Programming | |||
Hidden? macros | Excel Programming |