Sheet Tabs

  • Thread starter Thread starter JC
  • Start date Start date
J

JC

Hello All,

Is there a way to lock worksheet tabs so a user can
access certain sheets but not others. I do not think I
can hide the sheets as I have code that looks in the
sheets

Thanks in Advance
 
JC,

VBA can access hidden sheets, just don't select first.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Move or Copy Stopped Working? 0
Macro to Compile Data from Different Sheets 2
Macro to Combine Data from Multiple Sheets with Cell References 4
clear all sheets code 4
[Q] How to sort tabs in order of CodeName 2
Disable/enable or lock/unlock cells in VBA dependent on other cells values 2
hide multiple worksheets based on a formula value in one cell 1
Error Message - Macro to Unlink MS Queries from Workbook 0

Back
Top