ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Icon button - font/style (https://www.excelbanter.com/excel-discussion-misc-queries/941-icon-button-font-style.html)

cvgairport

Icon button - font/style
 
I have inherited a number of spreadsheets from someone who had left the
company and as I worked in them, I have attempted to apply fonts via the icon
buttons on the tool bar. Unfortunately, I receive an error message "Style
not found". Is there a fix for this?

Thanks!

Amy

Dave Peterson

Is it the currency style? (seems like a somewhat common problem)

Start a new workbook.
go back to your workbook (with the problem)

Format|Style|Merge
Point at that new workbook
Ok
Ok
(remember to save your workbook or you'll be doing this again.)

(Some how that style got deleted and you just added (merged) it back in.)

If the style that was lost isn't in a brand new workbook (user created), you
could recreate that style or find a workbook that still has that style and merge
from there.



cvgairport wrote:

I have inherited a number of spreadsheets from someone who had left the
company and as I worked in them, I have attempted to apply fonts via the icon
buttons on the tool bar. Unfortunately, I receive an error message "Style
not found". Is there a fix for this?

Thanks!

Amy


--

Dave Peterson


All times are GMT +1. The time now is 12:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com