Posted to microsoft.public.excel.crashesgpfs,microsoft.public.excel.misc,microsoft.public.excel
|
|
Scroll bar moves too short
Where does CTRL-G, Special, Last Cell take you to now?
Dima wrote:
The prompt window to allow a macro does not appear when I open the other file
with the copy of the sheet.
"Bob I" wrote:
There is certainly more to this than meets the eye. Perhaps you want to
copy just that worksheet to a new workbook instead.
Dima wrote:
Thanks Bob for the suggestion!
I did not find a macro that accesses a cell on row 50147 and I deleted all
marcos in the Macro window. But I still get a a window asking if I want to
allow running of macros at the xls file opening.
Regards,
Dima
"Bob I" wrote:
Then perhaps you have a macro that accesses a cell on row 50147?
Dima wrote:
Thanks Bob for replying!
I did not delete contents. I deleted the rows with R-click menu Delete. (not
pressing Delete key)
Regards,
Dmitry
"Bob I" wrote:
Sounds like you deleted contents not the rows. Delete the rows with
R-click menu Delete.(not pressing Delete key)
Dima wrote:
Thanks Bob for replying!
I deleted all rows after 473. This does not resolve the problem in my file.
Regards,
Dmitry
"Bob I" wrote:
Select and delete all rows after 473.
Dima wrote:
Thanks Niek for replying!
I did what is written on http://www.contextures.com/xlfaqApp.html#unused
This does not change anything in my file.
My scrollbar goes to row 50147 -- my data ends in cell BG473.
Regards,
Dima
"Niek Otten" wrote:
Hi Dima,
Look he
http://www.contextures.com/xlfaqApp.html#unused
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Dima" wrote in message
...
Hello!
A sheet scrolls to a data end with a vertical scroll bar in 1/50 of a
lenth
of a scroll bar area from the upper end.
How to make the sheet scroll to the data end with the scroll bar movement
to
the scroll bar area end?
Regards,
Dima
|