Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 32
Default Where are the hidden macros?

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 32
Default Where are the hidden macros?

Problem is solved. The hidden macros are from Excel 4.0.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macros with hidden sheets! Perini 9 Excel Programming 2 June 28th 05 08:38 PM
Unhide Worksheets (hidden via macros) Mark Excel Discussion (Misc queries) 1 June 7th 05 05:21 PM
excel macros truncating tabs for hidden columns. SharanS Excel Discussion (Misc queries) 0 February 17th 05 05:05 AM
running macros on hidden sheets? hammer Excel Programming 1 October 15th 03 10:47 PM
Hidden? macros Steve[_37_] Excel Programming 4 September 7th 03 04:48 PM


All times are GMT +1. The time now is 07:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"