always on top

J

Jorn

Board Regular
Joined
Jul 10, 2003
Messages
92
Good MOrning All!

I have tried a search, as i have seen this somewhere on the board but cant find it now. How do I make a form float on top of excel, but still enable the user to open excel workbooks and select them? (basically this is a pushbutton formatting program, and they need to be able to open certain worksheets and push a button on the form)

Can someone help?

Cheers!

John
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
Sort by date Sort by votes
Is it a VBA userform?

If so, and you are using Excel 2000 or higher you can make the userform modeless when you show the form using the following code:

Code: 
Userform1.Show vbModeLess

...just change the name "Userform1" to whatever the name of your userform is.
 
Upvote 0
That was certainly an attention getting subject line... :LOL: Made me look!

But Mark beat me to the punch on the solution (as usual...) :pray:

Smitty
 
Upvote 0
Argh!!! I have excel 2000 but the spreadsheet has to be recreated in 97- how can I have the VBA userform floating ontop, enabling the user to open, close and select other spreadsheets?

John.
 
Upvote 0
Hi John,

I think you're out of luck if you want fully modeless userforms in Excel 97. Stephen Bullen has done something fairly which sort of works, but you can't use toolbars when the form is displayed. See the ModelessForm.zip file here:- http://www.bmsltd.co.uk/Excel/Default.htm
 
Upvote 0
Would it be possible to have a way of searching directories to select the file to open? (ie, having options as if opening a file in the file menu?)

John.
 
Upvote 0
I am testing now. I find it very odd that i dont have that in my help directory. Very very odd. Its excel 97 (which i dont normally work with) so i dont know what is going on with it.

Thank you for your help.

John.
 
Upvote 0
You must log in or register to reply here.

Similar threads

E
  • Question
Old XLSM files crashing Excel; looking for help to troubleshoot, please
Replies
9
Views
1K
jkpieterse
jkpieterse
D
  • Question
Macro will protect worksheet, but will not unprotect
Replies
3
Views
576
rlv01
R
T
  • Question
VBA code to export specific variably named tabs to new workbook?
Replies
2
Views
437
thebigejr
T
P
  • Solved
Subscript out of range error 9 on windows activate
2 3
Replies
20
Views
804
MARK858
MARK858
H
  • Question
'How to' question about a Dashboard
Replies
5
Views
269
etaf
etaf

Forum statistics

Threads
1,215,657
Messages
6,126,061
Members
449,285
Latest member
Franquie518

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top