hello:
I really need your help.
I have some buttons in different sheets in an excel file, each button has its own code, that is the reason I can not move the code related to each object to another location (sheet or module).
And I have one piece of code in Module1 (Auto_load) in order to execute automatically this routine every time file is opened. Inside "auto_load" routine I initialize some values of some check buttons,options buttons and positions of some objects in diferent sheets, but I can not pass the value of variables between Module and Sheet's code even when I declare as public variables and/or function.
I have the following structure:
VBA Project
------Microsoft Excel Object
----------Sheet1 <-I have code here
----------Sheet2
----------Sheet3 <-I have code here
------Modules
----------Module1 <-I have code here
----------Module2
----------Module3
How I can pass the value of some variables between Module and sheets??
Thanks in advance.
Bookmarks