Conditional formatting based on decision to enable/disable macros?

  • Thread starter Thread starter zenahs
  • Start date Start date
Z

zenahs

I have an Excel workbook that is used by numerous individuals across th
province via our server. For this workbook to function properly, I nee
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 th
workbook if they choose to "Disable Macros"? Possibly through som
sort of conditional formatting? Or....??
Thanks
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro-enabled workbooks 1
security, enabling macros to enable a disabling saving function 12
disable 'enable macros' pop-up message on all computers 5
Why is conditional formatting disabled(!)? 3
Enable macro 3
Automatically disable macro's on new doc 12
Prevent workbook from opening if macros are disabled 7
Bypassing ENABLE/DISABLE MACROS message 1

Back
Top