Shared Files in Excel | General Excel Questions & Answers | Excel Forum • My Online Training Hub

Shared Files in Excel

cpatel

New Member

Members

Forum Posts: 1

Member Since:
June 25, 2016

Offline

June 25, 2016 - 5:40 am

I need help setting up shared files in Excel ( I use 2010 version). The file is to be used with protection and auto filters.

I have tried protect = UserInterface only and the auto filters work manually but not via vba code. Also, I have been able to use the code when developing the file, but if the file is closed and reopened, the vba code fails.

Currently, I am forced to leave the spreadsheet unprotected and control the accessible cell area via ActiveSheet.ScrollArea = range command in the worksheet Private area.

Any help would be appreciated - I am looking for a worksheet which is shared and protected with a range of unprotected cells and for which I can use the autofilter via vba code.

thanks

Ray Jones

New Member

Members

Forum Posts: 1

Member Since:
January 21, 2015

Offline

June 28, 2016 - 1:22 am

Have you tried using the Protect Sheet options?

Highlight the areas you want protected and right-click and select Format Cells. Click the Protection tab in the Format Cells dialog box. Check the Locked box.

In the File tab, under Info, select Protect Workbook and choose Protect Current Sheet. In the new dialog box there is a list of check boxes available. Each checked item allows the user to interact with the worksheet for the action listed. If you check the Use AutoFilter box (and any others you want allowed), would this solve your problems?

Just make sure you note the password to unprotect the sheet in case you need to have full access later. Wink