LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 397
Default Sheets - Limited acces

Howdie....
I need only certain sheets to be visible, depending on who is looking.

I looked at the previous submitted query today, but that response doesnt
work for me.

I have Five sheets.
Sheets One to Three (no pun intended :) ) are visible all the time
Sheets Four and Sheet Five only visible to a selective audience.
I would like to write VBA so that when the user runs the macro it asks
for a password, or username, and then if the correct answer is inputted,
it unhides Sheets Four or Five.
Too adventurous?
Other ideas welcomed...

Thanks!!

D

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Front end Acces Back end Ian B Excel Discussion (Misc queries) 1 February 9th 07 07:18 PM
Can I use Excel to make Inventory without using Acces? SPAINVENTORY New Users to Excel 3 January 13th 06 01:47 PM
Retrieving Acces Querry by Use of Macro Jasper Excel Programming 1 February 21st 05 01:16 PM
Working betwen excel and acces filo666 Excel Discussion (Misc queries) 5 February 16th 05 07:19 PM
Command and pass value to Acces from Excel Looko Excel Programming 0 May 31st 04 01:23 AM


All times are GMT +1. The time now is 07:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"