Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Viewing Two Sheets within One Workbook MCSHMCH Excel Discussion (Misc queries) 2 September 28th 07 03:46 AM
viewing two spead sheets in two separate windows arad Excel Discussion (Misc queries) 3 September 12th 07 12:56 PM
Viewing Excel sheets on the web digi duck Excel Discussion (Misc queries) 1 May 31st 06 09:48 PM
Viewing protected cells AC_VID Excel Discussion (Misc queries) 1 April 10th 05 01:21 AM
Viewing LOCKED cells AC_VID Excel Discussion (Misc queries) 1 April 9th 05 11:19 PM


All times are GMT +1. The time now is 09:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"