Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 312
  • Last Modified:

VB help

When you protect a sheet you have the option to enable the filter whilst protected.

The trouble I have is that when I use the command buttons on my spreasheet, when it "relocks" the page:-

Sheets("Archive").Protect Sheets("DataSheet").Range("B3").Value

The autofilter option is removed from the 'locked page', is there a way to change the code so that it locks the page but still allows the autofilter.

Or if easier, allow the command buttons to work without unlocking the page.
help19.xls
0
Kiwi-123
Asked:
Kiwi-123
1 Solution
 
SANTABABYCommented:
Your workbook is updated (attached).  Now the code allows autofilter while protecting the sheet.
help19.xls
0
 
Kiwi-123Author Commented:
Many thanks for yout help with this
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now