whatever.. i'd get rid of the € column and use cell formatting for the
last column.
if you want to check if a col is hidden
with Worksheets("Sheet1").Columns("C")
if .Hidden then .hidden=false
end with
it's a property from the range object..
however it wont work on a cell, it works on (series of)
Rows and Columns only
=select activecell.EntireColumn.Hidden will work
to just unhide all columns on the sheet use:
activesheet.columns.hidden=false
that what you wanted?
keepITcool
< email : keepitcool chello nl (with @ and .)
< homepage:
http://members.chello.nl/keepitcool
"Stuart" wrote:
We might be at cross-purposes here, due to my poor
explanation.
The user has chosen a sheet(s) to print, and has then
opted to hide a column(s). The sheet is a series of
'pages' finishing with a '£' value in col N (£Col) and
a total in col O at the end of each 'page'.
The values in col N above '£' in each page are Nett
values. If the user choses to hide these from the Client,
then they hide Col N.....which hides '£'.
I would like to trap user hiding col N (ideally a way to
trap any specific column being hidden), then if it is
hidden, add '£' to col M (same row) for a normal
sheet, or add to col O for a 'SUMMARY' sheet.
Then when each range ('page') is printed, the '£' is
there for presentation purposes.
Thanks for your responses.
Regards.
"keepitcool" wrote in message
...
use outlines,
then for presentation you select level 2 (unhiding the hidden
columns)
and the user works with level 1
keepITcool
< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool
"Stuart" wrote:
Col N contains user data. Every 50 odd rows or so, a '£' value
coincides where a 'Collection' row occurs. I need to permit
user to hide £Col, but for presentation purposes I wish to
add the '£' value as previously described.
Regards.
"keepitcool" wrote in message
...
I stopped using a separate column for Currency sign when I
transferred
from Lotus 123 to Excel in 1990. I use number formatting instead.
keepITcool
< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool
"Stuart" wrote:
How best to detect if a column (£Col) has been hidden
by the user, and if it has, then add a '£' to the cell
immediately to the left of it (same row), please?.
Since that cell will already contain data, I need to place
the '£' at the very righthand boundary of the cell.
So:
the original layout was:
Col M N O
Row
56 Collection £ 225404.29
If user hides col N, then I need to get '£' into M56
like 'Collection £', and if col M is not wide enough
then I need to widen it.
If the sheet is called 'SUMMARY' then '£' cannot go
into M56. It will have to go into O56, like
'£ 225404.29'.
O56 contains a SUM formula. Is that a problem?
Any help with any of these questions would be much
appreciated.
Regards.
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.505 / Virus Database: 302 - Release Date:
30/07/2003
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.507 / Virus Database: 304 - Release Date: 04/08/2003
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.507 / Virus Database: 304 - Release Date: 04/08/2003