Hi,
I have the following code that works fine except cells that I want "locked" are not locked. I can't find the "select unlocked cells" property as I'm a novice. How do you perform this with VBA code in Excel 2010? Cell A1 is the date being pulled from Worksheets(2) and I don't want the user to be able to change it when they run the pivot table report.
Any help will be appreciated Thanks!
Please Login or Register to view this content.
Try this...
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
I appreciate the help, but I get a compile error "Expected: named parameter" with the "AllowFiltering=True" being highlighted when trying that solution.
When I have "Worksheets(3).Protect "pass" with one of "AllowFiltering = True" or "AllowUsingPivotTables = True", the worksheet gets locked like I want; however, the pivot table's filters are also locked and I don't want that.
Missing two colons :
Please Login or Register to view this content.
Awesome. Works now! Thanks.
Out of curiosity, what do the colons signify (remember, I'm a novice)?
The .Protect is a vba Method and AllowFiltering is an Argument for that method.Originally Posted by Murman01
argument:=value is the syntax used to set the value for a method's argument.
This explains the difference between a Method (like .Protect) and a Property.
Much appreciated!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks