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: 28
Default UserForm as a tool bar/ floating options for excel sheet

I am creating a program where I need a variety of buttons and check
boxes that do stuff to the excel sheet. Just using the excel forms
doesn't work because when I zoom out (which the program needs to be
able to do), the buttons get small and unreadable.

So, I would like to be able to create a floating toolbox that has the
buttons and checkboxes in it. I tried a UserForm, but it seems that the
userform requires itself to be deactivated before excel can calculate
anything. Is there any way to have a userform where the worksheet can
be calculated (I am using manual calculation) while the userform is
still up and active).

The goal is to have a floating Start/Stop button that controls whether
or not the worksheet is calculating or not.

Thanks in advance,

Abe

 
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
tool: options disabled Sara Excel Discussion (Misc queries) 1 April 17th 06 07:05 PM
Why would excel tool bar options be grayed out? Bugs Excel Discussion (Misc queries) 3 January 10th 06 10:10 PM
Floating userform MD Excel Programming 1 March 2nd 05 03:24 AM
'Floating' UserForm paulw Excel Programming 2 October 29th 03 04:48 PM
Tool-Options-Calculations Wendy[_3_] Excel Programming 0 August 7th 03 08:09 PM


All times are GMT +1. The time now is 01:18 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"