Go Back  Xtreme Visual Basic Talk > Legacy Visual Basic (VB 4/5/6) > VBA / Office Integration > Excel > Excel Display options code change


Reply
 
Thread Tools Display Modes
  #1  
Old 05-24-2005, 10:44 AM
Raj7 Raj7 is offline
Centurion
 
Join Date: Feb 2004
Posts: 110
Question Excel Display options code change


Hi,

You can edit the options on excel so that the user cannot see things such as the sheet tabs and the scroll bars.

I have a login optoion on my sheet and was wondering if there was any way in whic i could write some code so that once the user has logged in items such as the sheet tabs and scroll bars reappear

Thanks

Raj
__________________
"Don't be afraid your life will end; be afraid that it will never begin"
Reply With Quote
  #2  
Old 05-24-2005, 10:48 AM
NateO's Avatar
NateO NateO is offline
Excellent…

Forum Leader
* Expert *
 
Join Date: Jun 2004
Location: Minneapolis MN - deceased
Posts: 2,483
Default

Sure, record the code for syntax and dump it into a Workbook Open event. See the following for background on Excel Event procedures:

http://www.cpearson.com/excel/events.htm
__________________
Regards,
Nate Oliver
Microsoft Excel MVP
Reply With Quote
  #3  
Old 05-24-2005, 12:36 PM
Raj7 Raj7 is offline
Centurion
 
Join Date: Feb 2004
Posts: 110
Default

Thanks worked perfectly

Raj
__________________
"Don't be afraid your life will end; be afraid that it will never begin"
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
 
 
-->