Hi, I'm trying to save a custom Format Cells so that I can use it in any workbook.
I've already created and saved 2 Excel Template files namely "Book" & "Sheet" inside the folder C:...\AppData\Roaming\Microsoft\Excel\XLSTART
But only when I open a new / blank workbook then I can see the custom Format available there but not getting it in any other saved workbooks.
Can somebody help me with this?
The only way to do this that will be available in any workbook you open is to write a macro to apply the format. You can then call the macro from a custom Ribbon button, or the QAT. I think there may be a way to add it to the right-click menu for a cell but I'm rusty on that.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks