code to update very hidden sheets in a protected workbook

[Balachan56]

Hi all,

I have an excel workbook that stores user information: login names, passwords, employee IDs etc. This info is checked in order to permit authorised users to login and enter/process data. However, for the sake of protection the information sheet is made very hidden via code and the workbook, protected with a password. However, errors crop up whenever the workbook is protected and the sheet very hidden. These errors do not occur when the workbook protection and the 'very hidden' sheet attribute are removed.

I am not able to remove the very hidden attribute via code, if the workbook is protected. I need to know
1. how to code so that user information can be entered without the very hidden attribute and workbook protection having to be removed (or atleast not in a manner obvious to the user).
2. How to code in order to remove the very hidden attribute of a worksheet in a protected workbook.

I'd appreciate useful suggestions. Thanks in advance,
Bala

[broro183]

hi Bala,

I'll respond to this thread & leave the previous historical thread, http://www.excelforum.com/excel-prog...rksheet-2.html, because the title of this thread is better matched to your latest questions.

An uploaded file is really necessary now for Helpers to understand exactly how you have currently coded the macros - so we can fix any errors without having to guess at the current code/errors.
Can you please upload your latest version of the file with all the code (& some dummy data)?

Thanks
Rob