View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
ross ross is offline
external usenet poster
 
Posts: 81
Default Minimise Form Button + Linked Wrokbooks Warning

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