I dont want to see formula at selection area , only values
need macro to do so.
I dont want to see formula at selection area , only values
need macro to do so.
Turn on the macro recorder
then select your cells, format => cells, go to the protection tab and click
both locked and hidden
then protect your worksheet
Turn off the macro recorder.
Look at the recorded code.
--
Regards,
Tom Ogilvy
"moshe" <[email protected]> wrote in message
news:[email protected]...
> I dont want to see formula at selection area , only values
> need macro to do so.
Hi
just wondering why you need a macro for this, as copy then edit / paste
special - values works well in most situations.
--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"moshe" <[email protected]> wrote in message
news:[email protected]...
>I dont want to see formula at selection area , only values
> need macro to do so.
If you actually want to replace the formula with values as JulieD describes
Sub ReplaceWithValues()
selection.Copy
selection.PasteSpecial xlValues
End Sub
--
Regards,
Tom Ogilvy
"JulieD" <[email protected]> wrote in message
news:[email protected]...
> Hi
>
> just wondering why you need a macro for this, as copy then edit / paste
> special - values works well in most situations.
>
> --
> Cheers
> JulieD
> check out www.hcts.net.au/tipsandtricks.htm
> ...well i'm working on it anyway
> "moshe" <[email protected]> wrote in message
> news:[email protected]...
> >I dont want to see formula at selection area , only values
> > need macro to do so.
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks