Protecting hidden columns

  • Thread starter Thread starter PeterA
  • Start date Start date
P

PeterA

Hi Would appreciate advice...........
What is the best way to ensure hidden columns are
protected from users being able to unhide them??
Thanks in advance
PeterA
 
One way might be to limit the scroll area. From vba help.

ScrollArea Property
See Also Applies To Example Specifics
Returns or sets the range where scrolling is allowed, as an A1-style range
reference. Cells outside the scroll area cannot be selected. Read/write
String.

Remarks
Set this property to the empty string ("") to enable cell selection for the
entire sheet.

Example
This example sets the scroll area for worksheet one.

Worksheets(1).ScrollArea = "a1:f10"
 
What is the best way to ensure hidden columns are

How sure is ensure? Excel protection is limited at best and will defeat the
vast bulk of users, but, most regulars on here would defeat that in a nanosecond
regardless of what you used, so just be sure it isn't that sensitive it will get
you into trouble if it is found out. If this is data going to a customer and it
is likley to contain pricing rates etc then rethink this now.
 
Back
Top