Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I have two what I hope are relatively simple questions but I can't seem to find any info about them. The first is - when I create a UserForm it automatically comes with a X button in the top right hand corner to close the form. Is there anyway for me to get a minimise button up there too? I am using the form as a menu in the spreadsheet so I want to be able to minimise it and maximise it again when needed. The second question is - whenever I open a spreadsheet I get this "prompt": "The workbook you opened contains automatic links..." And I have to chose yes or no. Is there anyway I can either a) get rid of this altogether or b) when I open the spreadsheet I pass 'No' in straight away so I don't have the prompt. I am trying to gather information from about 100 different spreadsheets and put it into one so having to click the 'No' button 100 time would be slightly irritating. Thanks in advance, ennui |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I create a warning message on a command button | New Users to Excel | |||
EMPLOYEE WARNING FORM | Excel Discussion (Misc queries) | |||
Add a warning popup to a Macro Button | Excel Worksheet Functions | |||
Hide minimise, maximise, and close buttons on form | Excel Programming | |||
Disabling the minimise button in Excel workbook | Excel Programming |