Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variables Held in Sheet Module
Hidden in cells to the far right of row1 are 12 variables. Some are
used to set the condition of CommanBar Controls when a worksheet event occurs; others are displayed as a value on a worksheet properties userform. This worked well until recently when a user deleted row1. I did think that any text written in the Sheet Module would be detected when the workbook was opened if the Macro Security Level was set above the lowest level. I was surprised to find that I could save the workbook with a variable name and value, shCondition = "formatted" or line number 1 = "formatted", and open the workbook without tripping the Macro Security. This may be completely useless, but is there perhaps a method that can be used to read and write variables in a Sheet Module? Thanks as always for your help Regards Phil |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Declaring variables in Module vs. Public | Excel Discussion (Misc queries) | |||
Create Global Variables in a module | Excel Programming | |||
4 variables to one sheet, then back to original sheet with answer | Excel Programming | |||
Passing variables from module to userform | Excel Programming | |||
Variable from a sheet module in a class module in XL XP | Excel Programming |