View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default Viewing same cells at the same time in two sheets

CDO is the web interface of the newsgroups


--


Regards,


Peo Sjoblom


"Bob Umlas, Excel MVP" wrote in
message ...
"CDO"??? What's that?
And WHAT's what happens? -- my post going in twice? (maybe I was in
[group]
mode!)

"Peo Sjoblom" wrote:

That's what happens when you use the CDO <g


--


Regards,


Peo Sjoblom



"Bob Umlas, Excel MVP" wrote
in
message ...
In the VBE, enter this in the immediate pane (ctrl/G):
application.Dialogs(xlDialogWorkgroup).Show
Deselect what you DON'T want, and then whatever you do in one workbook
will
be done in both (all) for the selected sheets. If this is a duplicate
post
(by me), it's because it seemed it didn't take the first time, so
apologies!
Bob Umlas

"Clark" wrote:

I want to open two separate worksheet files in the same window, then
make
changes in cells to worksheet 1, and have those same changes occur in
worksheet 2.