LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 40
Default One sheet per window and no Ribbon

ingI'm writing an Excel application in VBA and I'd like to be able to do the
following

1) Hide and deactivate the ribbon so the user of my app won't accidently do
something he/she shouldn't

2) Lock a specific window to a specific worksheet -e. g. make the user
unable to change worksheets within a window. Presumably this would involve
making the worksheet tabs at the bottom of a window dissappear.

How might I accomplish the 2 things mentioned above?

--
-regards
 
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
Opening Excel sheet in its own window prpc Setting up and Configuration of Excel 4 July 13th 07 01:36 PM
How to Link on [Sheet(1) Window(1)] to [Sheet(2) Window(2)] ? EagleOne Excel Discussion (Misc queries) 0 November 22nd 06 03:48 PM
The window opens in a smaller window not full sized window. Rachael Excel Discussion (Misc queries) 0 November 7th 06 09:04 PM
Ribbon vs. Menus mifukhed Excel Discussion (Misc queries) 4 June 1st 06 07:14 AM
Excel window in spread sheet? WTG Excel Discussion (Misc queries) 3 April 14th 05 07:03 PM


All times are GMT +1. The time now is 01:48 PM.

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"