I can't call this a bug ... because i dont know what i am doing !
Being a happy and contented soul - i had no need of userforms - i dont mind if all the controls are on a workbook sheet.
However - for a lark - i decided to venture into userforms - first time in about 9 years !
Got it all working a treat - eventually ! So i could doubleclick on the workbook on the desktop, the Excel workbook is briefly visible, then only the userform can be seen - great - got it - job done !
Ha !
Just opened the same workbook from with Gruss BA v - O pandemonia ensures ! ( no - thats not a panda with pneumonia - but it might be ! )...
From Tab 'Excel' , 'Log current prices' - to 'browse' - select file - file name & Worksheet appear in the textboxes.... then - currrr wallop ! my excel file opened - the workbook flashed visible, the userform appeared - the workbook property changed to visible.false - as it is supposed to - but in " Excel - log current prices" - the textboxes for "Workbook name" & "Worksheet name" - were blank !
stupid , stupid me ! I have made the workbooks invisible
but GRuss BA has locked
Seems there is a conflict of interests - I dont want to see the workbooks at all ( not ever - just the userform ) - but it seems GrussBA must be able to see the workbooks.
So question - if i compromise - and leave the workbooks open whilst i continue filling in the details on the "Excel - log current prices" window - and click "OK" - can i make my workbook invisible then - and will GrussBA be able to 'see' the workbook to send data to / recieve betting instruction therefrom ?
or, have I been such a clever dick - i have just nuked myself ?
