P
peterfarge
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.
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.