i have also got a userform on the side running in paralel with my
spreadsheet
But the thing is i cant use my spread sheet unless i close down my
userform anyone know a way i can use both these in conjunction with
each other?


---
Message posted from http://www.ExcelForum.com/

What version of Excel are you using? In Excel 2000 and later, you
can show the form "modelessly", which will allow you to switch
between the worksheet and the form. Use the following code to
show the form:

Userform1.Show vbModeless


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com





"DaveyB" wrote in message
...
i have also got a userform on the side running in paralel with
my
spreadsheet
But the thing is i cant use my spread sheet unless i close down
my
userform anyone know a way i can use both these in conjunction
with
each other?


---
Message posted from http://www.ExcelForum.com/

excel 97 and thxn for your help


---
Message posted from http://www.ExcelForum.com/

See ModelessForm at Stephen Bullen's page
http://www.bmsltd.co.uk/Excel/Default.htm

--
HTH. Best wishes Harald
Followup to newsgroup only please.

"DaveyB" wrote in message
...
excel 97 and thxn for your help


---
Message posted from http://www.ExcelForum.com/