Preserving page setup upon query refresh

P

pepenacho

Hello

I'm running a query in an Excel sheet from Access. The data is changing. I have a set of formatting rules in page setup that I would like to preserve during any refresh - the refresh seems to abolish the setups I have. Setting up a style does not work well

Is there an effective way of doing this, for example through code in macro

Thanks
pepe
 

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

Need Help with Macro Security 1
Section and Page numbering 0
Page numbering with Merged Document and IF statements 1
Finding the proper style field and the numbered paragraph value within the style 0
Finding the right style field in VBA 0
Preserve Formatting for Pivot table cross 'Refresh Data !' 0
excel external data range "failed to refresh" 0
Locking column width - upon refresh of PivotTable 0

Top