Hi again,
The title explains it pretty well, LOL! Is it possible to use VBA to set the width of the whole workbook?
Jenny
Hi again,
The title explains it pretty well, LOL! Is it possible to use VBA to set the width of the whole workbook?
Jenny
Do you mean the whole Excel application window?
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Not the whole Excel Window, just the particular workbook that I'm working with. I already have a macro to format (etc) the worksheet, but I hoped to change the width of the workbook itself so that they're the same width each month.
Nobody else at my work would care, but I do. (There's a CHANCE I might be a little OCD, LOL!)
Not sure what you mean, then. Do you mean column widths?
Try posting a screenshot of what you start with, and what your required outcome looks like.
Sorry, often I'm not real clear at explaining things.
The "main" excel window is the size of my screen, and I've got the column widths the way I want them. What I want to change is the width of the workbook that the worksheet is located in. So, if the path to the file is, for example, "C:\Imports\Financial\Analysis\09-14", I want to change the width of "09-14", not an individual worksheet within "09-14".
Jenny
Hmmm, I can't seem to figure out how to post a screenshot. I've done it before, but it won't let me today.
Okay. I'm guessing you are opening multiple workbooks within one Excel application instance.
This is a display option in Excel 2010. This ability was removed in Excel 2013 - each workbook opens in its own application instance.
I'm guessing you want to resize the workbook window within the (maximized) Excel application? Is this right?
I'm afraid I can't help any further - only have 2013 on this PC, to play with. Will ask for more help from others.
Okay, thanks for trying. I only want to change the width for this one report, so I'm hoping to be able to add it to my macro.
Have a great day!
Jenny
this seems to work for me....it's a take on Olly's code...
set the 750 to what ever you want...
put this right after you open the window or run the macro while the workbook is active....
Please Login or Register to view this content.
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
AWESOME! That works perfectly!!
Thanks judgeh and Olly; You guys rock!
Jenny
no problem....Olly is really good at VBA....have a great day....
Thanks Olly
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks