View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default How to copy or share "Custom Views" from one sheet to another

You can't edit the Custom View settings manually or programmatically, or
copy a Custom View, so you won't be able to use an existing as the basis
for a similar view on a different sheet.

Perhaps you could record a macro instead, as you change the settings on
a worksheet, and run that macro as required.

Nauj Solrac wrote:

--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html