How to add a worksheet from template without duplicate cell styles

Z

Zeq

I need to add worksheets based on worksheet templates to a workbook. I would
like to use the cell style "normal" as defined in the workbook. However, all
cells in the added worksheet with style "normal" now have style "normal 2"
and will not use the formatting set in the original workbook. Is there any
way to get around this without going through all cells in VBA and changing
the style?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to modify and updte specific styles for specific paragraphs across the document 0
Problem with MS Word paragraph and character styles: format getting messed up 2
creating new template - change default heading style 7
Need help modifying code 0
Pasting from the clipboard 3
Manual or Automatic Paragraph Spacing? 2
Template location changes from user to user 0
Change style in document template, but other docs dont update! 3

Top