<div>
excellent rob...<br />
<br />
just need to amend to include two more worksheets<br />
<br />
1. card<br />
2. phone..
</div>


<div>
that's the above code....and consider questions closed...
</div>


<div>
Thanks for the points - I'm pleased I could help :-)<br />
<br />
Rob
</div>


<div>
hi rob<br />
<br />
can you kindly help with...<br />
<br />
<br />
<a href="https://www.experts-exchange.com/questions/28174602/compile-error-variable-not-defined.html" rel="ugc">https://www.experts-exchange.com/questions/28174602/compile-error-variable-not-defined.html</a>
</div>


<div>
<div class="content wysiwyg-content">
Hi Experts<br />
<br />
Need a macro to unhide a specific worksheet &quot;Source Data&quot; from worksheet &quot;master&quot; where the macro is going to be run from....<br />
<br />
but before the worksheet is displayed made visible the user has to enter a password in order for the sheet to be displayed to the user...
</div>
</div>


Hi Experts

Need a macro to unhide a specific worksheet "Source Data" from worksheet "master" where the macro is going to be run from....

but before the worksheet is displayed made visible the user has to enter a password in order for the sheet to be displayed to the user...

excellent rob...

just need to amend to include two more worksheets

1. card
2. phone..

that&#39;s the above code....and consider questions closed...

Thanks for the points - I&#39;m pleased I could help :-)

Rob

hi rob

can you kindly help with...


http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_28174602.html

Macro to unhide specific worksheet via password

Hi Experts

Need a macro to unhide a specific worksheet &quot;Source Data&quot; from worksheet &quot;master&quot; where the macro is going to be run from....

but before the worksheet is displayed made visible the user has to enter a password in order for the sheet to be displayed to the user...

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.