Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting based on decision to enable/disable macros?
I have an Excel workbook that is used by numerous individuals across the province via our server. For this workbook to function properly, I need each user to choose "Enable Macros" upon opening the workbook. However, they are still able to access the workbook regardless of their decision. Is there a way to prevent the users from viewing/editing/etc the workbook if they choose to "Disable Macros"? Possibly through some sort of conditional formatting? Or....?? Thanks. -- zenahs ------------------------------------------------------------------------ zenahs's Profile: http://www.excelforum.com/member.php...o&userid=28681 View this thread: http://www.excelforum.com/showthread...hreadid=485245 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting based on decision to enable/disable macros?
The standard way to approach this is as follows. - create a worksheet with a message on explaining that for this workbook to run it needs macros enabled, maybe even a few screenshots - hide all other worksheets - add some code in the Workbook_Open event that unhides the other sheets, but hides that sheet. What happens is that if they do not enable macros, they will only see the warning sheet, telling them how to do it. If they enable macros, it will startup the workbook as it should be. -- HTH RP (remove nothere from the email address if mailing direct) "zenahs" wrote in message ... I have an Excel workbook that is used by numerous individuals across the province via our server. For this workbook to function properly, I need each user to choose "Enable Macros" upon opening the workbook. However, they are still able to access the workbook regardless of their decision. Is there a way to prevent the users from viewing/editing/etc the workbook if they choose to "Disable Macros"? Possibly through some sort of conditional formatting? Or....?? Thanks. -- zenahs ------------------------------------------------------------------------ zenahs's Profile: http://www.excelforum.com/member.php...o&userid=28681 View this thread: http://www.excelforum.com/showthread...hreadid=485245 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formatting with formula | Excel Worksheet Functions | |||
Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) | |||
Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) | |||
How to do a conditional formatting based on an adjacent cell | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) |