Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Hi there, I have used this newsgroup a number of times now, and people have always been very helpful. My next question, :) I have a macro which opens up a Data / Form dialogue box on a different sheet to where the macro is called from. The macro is a user input form and I have used a different sheet so I can display instructions for the user to refer to. When the dialogue box opens, its initial position seems random. I need it to display in the top-center of the sheet so I can wrap guidance around it. I can position the box myself, and then when I close it and call it again from the macro, it remembers that position, but it is the initial call when the spreadsheet is opened which fails to position it where I need it. I could give the users guidance how to position it but would rather not. Is there any way I can force an absolute display position when I call it? Many thanks in advance. Mark Flaxman |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need help positioning data labels | Charts and Charting in Excel | |||
Data Series Label Positioning | Charts and Charting in Excel | |||
Positioning charts & pictures with data for printing | Excel Discussion (Misc queries) | |||
Secondary Y-Axis -- Positioning of Plotted Data | Charts and Charting in Excel | |||
Two responding dialogue boxes for data validation | Excel Discussion (Misc queries) |