when you right click on a cell, it brings up a window. This window has tabs
on it, I can not see all the tabs and can not figure out how to change the
windo size to see all the tabs. Help
when you right click on a cell, it brings up a window. This window has tabs
on it, I can not see all the tabs and can not figure out how to change the
windo size to see all the tabs. Help
On Wed, 12 Oct 2005 11:54:02 -0700, KHall1968
<KHall1968@discussions.microsoft.com> wrote:
>when you right click on a cell, it brings up a window. This window has tabs
>on it, I can not see all the tabs and can not figure out how to change the
>windo size to see all the tabs. Help
Right clicking on a cell simply brings up a menu of the sorts of
things you can do with that cell. i.e. Copy, Format, Delete etc..
When you say it brings up a window, are you saying that there's
perhaps a VBA macro which runs as a result of a right click event on
any cell in the sheet and which opens up a Form window?
If so it may be that the form has not been made wide or tall enough.
If so, simply
1. Open the VB Environment with ALT - F11
2. Make sure the VBA Project Window is showing, if not click the View
Menu and select "Project Explorer.
3. Expand the "+" symbol on the Workbook name in question
4. Find the "Forms" object and expand the "+" symbol
5. Select the Form that's giving you a problem and drag the handles to
enlarge it as appropriate.
6. Close the VB Environment by clicking the usual "x" in the corner.
HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
Thank you so much. I now have it the size I need.
"KHall1968" wrote:
> when you right click on a cell, it brings up a window. This window has tabs
> on it, I can not see all the tabs and can not figure out how to change the
> windo size to see all the tabs. Help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks