PDA

View Full Version : Solved: Before Close unfilter on protected/shared workbook



rmarchetti97
06-24-2009, 12:14 PM
Hi,
I have a shared workbook with three protected worksheets that I would like to create a before_close macro on to unfilter any filtered columns. I would please love some help with the vba code to accomplish the following:


Unshare the workbook (can I do that?)
Unprotect each worksheet (the password is protect)
Removed the autofilter for each worksheet
Add back the autofilter for each worksheet
Protect each worksheet
Share the workbookI am totally new to this, and have been researching how to do each piece but am coming up short. An example is attached. Thank you!:hi:

Oorang
06-29-2009, 09:41 AM
Hello,
Welcome to the board. I see you marked this solved. Would you mind posting the solution so future readers may benefit?