Minimise Form Button + Linked Wrokbooks Warning

[ennui]

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

 

[ross]

Hi pal,

RE forms,
I am doing the same thing, cooldn't find a way. I ended up having 2
forms, one small and with the posistion on start up set to windows
standard, which puts it in the top of the window. This is ok for me
becasue i only want to move the form to see some other data, but you
cant work on the work sheet, beaces the form is still active, so not
very good really!
May be you could use a custom toolbar, or menu, which you "load" and
unload with the work book or work sheet, not ideal, but same fuction.

Re linking
i guss there may be a set up option, look in tools >options, if not,
you might beable to use the Application.DisplayAlerts = False, show
how, maybe have a open book and set this up, the open your other
books?

Sorry can't be of more help, good luck buddy
ross
x

 

[ennui]

In case anyone references this in the future:

I discovered that when calling the Workbooks.Open() function you cane
set UpdateLinks to false so it doesn't prompt you

The code looks like this:

Set MyWorkBook = Workbooks.Open(FileName:=WBFullName,
UpdateLinks:=False)