Thread
:
Disable "Save" &/or "Close"
View Single Post
#
4
Posted to microsoft.public.excel.programming
Nick Hodge[_4_]
external usenet poster
Posts: 11
Disable "Save" &/or "Close"
Ed
Much depends on how much editing has been done by way of ddeleting rows, as
XL does not reset it's UsedRange setting easily.
You could however put, in place of the fixed range
For each mycell in Range("A1:A4")
For Each myCell in Worksheets("Sheet1").UsedRange
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS
universal wrote:
Thanks Nick,
That works a treat!
Any ideas how I might handle this in reverse? The users return data
in varying amounts (some have hundreds of rows, while some may only
have a couple).
Maybe the macro needs to determine how far down (how many rows) the
spreadsheet data goes. Or to look towards the data validation columns
already on the right, so that if that range is TRUE/1, the msgbox is
displayed.
Maybe Im looking at this the wrong way though!!
Many thanks,
Ed
------------------------------------------------
~~ Message posted from
http://www.ExcelTip.com/
~~ View and post usenet messages directly from
http://www.ExcelForum.com/
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS
Reply With Quote
Nick Hodge[_4_]
View Public Profile
Find all posts by Nick Hodge[_4_]