Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default Macro Button

I've created a workbook with some "management eyes only" worksheets but other
sheets need to be seen by all employees. The document opens up to a home
page with macro buttons that when selected go to specific tabs in the
document. When left the tabs are hidden. My question I'm seeking help with
is if there is a way that when a particular macro button is selected, it asks
for a password that must first be entered before going to one of these sheets
that isn't open to everyone. Any ideas.
 
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
Macro button that others can see Newbee Excel Worksheet Functions 2 May 28th 08 05:17 PM
How do I add a button with a macro? [email protected] Excel Discussion (Misc queries) 1 November 13th 07 07:46 PM
Macro Button Gary Excel Discussion (Misc queries) 4 October 5th 07 01:30 PM
Using Macro to sort without clicking on macro button dd Excel Discussion (Misc queries) 3 May 3rd 07 06:00 PM
use macro button to run macro in protected sheet earl Excel Discussion (Misc queries) 3 February 26th 06 10:21 PM


All times are GMT +1. The time now is 03:07 PM.

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

About Us

"It's about Microsoft Excel"