ExcelBanter - View Single Post

Alan

"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.