VBA Protecting a sheet to prevent unhide column but allow outlining

[miless2111s]

I have some code to protect a sheet which prevents the user from un-hiding columns:

wsh.protect password:="xxx", AllowFormattingCells:=True, userinterfaceonly:=True

however i have also used in other sheets

wsh.Protect Password:="xxx", AllowFormattingCells:=True, userinterfaceonly:=True, DrawingObjects:=True 
wsh.EnableOutlining = True

I suspect the latter to was to allow the user to open and close outlining and interact with pivot tables etc (this was a while ago so I am not sure)

In the sheets protected by the latter code the users are able to un-hide columns which isn't good.

How do I allow them to interact with pivots and grouped / outlined rows and columns but NOT un-hide columns and rows?

Many thanks

Miles

 

[Jeffrey Mahoney]

Outlining is essentially hiding and unhiding columns or rows. So with .EnableOutlining on, they can unhide columns.

Can you move the columns to another sheet? Can you move the columns way over to the right so they can't see them? You could hide formulas that reference them so they have no idea to check in column ZZ.

Just a couple thoughts