2 windows for workbook - Macro switches worksheet
 

Hi,

I use a shortcut macro for doing paste special values of formulas from
one series of cells to other and it works just fine.


Sub PasteSpecialValues()
'
' PasteSpecialValues Macro
' Macro recorded 6/8/2006 by Hari Prasadh
'

'
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False

End Sub

Today, I had 2 windows of the same workbook open and when I was copying
some formulas from one worksheet and pasting in another worksheet
(different window of the same workbook) the first window's worksheet
also changed to second window's worksheet.

Why would this switch hapen?

Regards,
HP
India

2 windows for workbook - Macro switches worksheet
 

Since the two windows are for the same workbook, you change one will
automatically change another.

--
Best regards,
---
Yongjun CHEN
==================================
- - - - www.XLDataSoft.com - - - -
Free Excel/VBA Tool & Training Material
==================================
"Hari" wrote in message
ups.com...
Hi,

I use a shortcut macro for doing paste special values of formulas from
one series of cells to other and it works just fine.


Sub PasteSpecialValues()
'
' PasteSpecialValues Macro
' Macro recorded 6/8/2006 by Hari Prasadh
'

'
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False

End Sub

Today, I had 2 windows of the same workbook open and when I was copying
some formulas from one worksheet and pasting in another worksheet
(different window of the same workbook) the first window's worksheet
also changed to second window's worksheet.

Why would this switch hapen?

Regards,
HP
India