Hello again all!! thought i would try to get help in using Workbook_BeforeClose(cancel As Boolean) to auto lock 2 sheets (tabs) in one of my workbooks.
The one tab is called "Employees" (sheet1) and the second tab is called "Employee Info" (sheet 3). Can I get an example as to how to auto relock those 2 tabs after the book is closed?
Last edited by Vdogeek; 05-23-2014 at 12:29 PM.
Hi, Vdogeek,
I doubt this will be possible. You may use the Event but would need to save the workbook after locking sheets before closing the workbook.only after the book is closed
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Thanks for pointing that out, I refrased it above..."Can I get an example as to how to auto relock those 2 tabs after the book is closed? "
Hi, Vdogeek,
and I repeat that this canīt be performed as this action needs to be taken when the workbook is still open, it must be saved and the closed. No code for your request possible Iīm afraid.
Code goes into ThisWorkbook:
Ciao,
Please Login or Register to view this content.
Holger
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks