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: 5
Default Minimise Form Button + Linked Wrokbooks Warning

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
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
How do I create a warning message on a command button lkreeder New Users to Excel 4 February 1st 09 04:52 PM
EMPLOYEE WARNING FORM dawni Excel Discussion (Misc queries) 2 July 10th 06 10:28 PM
Add a warning popup to a Macro Button Teresa Excel Worksheet Functions 4 January 16th 06 09:27 PM
Hide minimise, maximise, and close buttons on form Gordon Garnsey Excel Programming 3 March 1st 04 02:41 PM
Disabling the minimise button in Excel workbook David Excel Programming 5 November 26th 03 12:08 PM


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