Menu

Test For Macro Security Settings Level

Search this Thread

#1

Report Post

Posted to microsoft.public.excel.programming

Alan

Alan is offline

external usenet poster

Posts: 188

Default

Test For Macro Security Settings Level

"Tony White" <Tony wrote in message
...

OK. That sounds like a good plan. Hopefully they follow directions
instead of unhiding the hidden sheets.

If anyone knows a way to prevent them from unhiding the sheets, I'd
like to know as some of these folks don't read or follow directions
:)

Thanks Alan!

Hi Tony,

My take on that is that for someone to even *know* how to change a
sheet from veryhidden to visible means they are probably a relative
expert in excel being able to use the VBE and Immediate Window
therein - most 'power users' won't even know how to do that.

If they choose to go down that route and not follow instructions, then
they are being deliberately awkward and / or malicious and in a
corporate scenario that should imply a serious career discussion with
their manager.

When using excel, as a 'developer' all you can really do is make it
plain what the user needs to do, and take reasonable precautions to
stop things going wrong - you cannot fully secure a basic excel
workbook in a practical way and if you need that level of 'bullet
proofing' then excel is probably not the right tool for the job.

Either way - Good luck!

Alan.

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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
Not able to KEEP Macro Security Level At Minimum	Carl	Excel Discussion (Misc queries)	2	March 5th 06 08:17 AM
Detecting Macro Security Level	Ed Ferrero[_5_]	Excel Programming	0	June 15th 04 01:22 PM
Detecting Macro Security Level	arkimediz	Excel Programming	0	June 15th 04 11:47 AM
Macro to change security level	Michael Miazga[_2_]	Excel Programming	2	July 21st 03 08:39 PM

All times are GMT +1. The time now is 04:11 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement