A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Powerpoint, Publisher and Visio » Visio
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Hide all shapes in a group



 
 
Thread Tools Display Modes
  #1  
Old June 27th, 2004, 11:25 AM
Blackend
external usenet poster
 
Posts: n/a
Default Hide all shapes in a group

Howcome when i add the geometry table, and set the Geometry1.NoShow the spaes are not hidden - they stay visible.
Is there another way for doing this (all shapes with one setting) ? - except hiding every shape in the group
  #2  
Old June 27th, 2004, 11:28 AM
Blackend
external usenet poster
 
Posts: n/a
Default Hide all shapes in a group

I ment "The shapes are not hidden"

"Blackend" wrote:

Howcome when i add the geometry table, and set the Geometry1.NoShow the spaes are not hidden - they stay visible.
Is there another way for doing this (all shapes with one setting) ? - except hiding every shape in the group

  #3  
Old June 28th, 2004, 02:04 PM
Chris Roth [ Visio MVP ]
external usenet poster
 
Posts: n/a
Default Hide all shapes in a group

Are you setting Geometry1.NoShow = True to go invisible?

A nice technique is to use formula referencing, after adding a user cell:

User.Hide = True
Geometry1.NoShow = User.Hide
Geometry2.NoShow = User.Hide
Geometry3.NoShow = User.Hide
....

Or, you can turn off the line and fill patterns:

User.Hide = 0 or 1
FillPattern = Guard(User.Hide)
LinePattern = Guard(User.Hide)

Using Guard will keep the user from destroying your smarts by applying line
and fill formatting from the dialogs and toolbars.

--

Hope this helps,

Chris Roth
Visio MVP


"Blackend" wrote in message
...
Howcome when i add the geometry table, and set the Geometry1.NoShow the

spaes are not hidden - they stay visible.
Is there another way for doing this (all shapes with one setting) ? -

except hiding every shape in the group


  #4  
Old June 28th, 2004, 08:42 PM
Blackend
external usenet poster
 
Posts: n/a
Default Hide all shapes in a group

Hi Chris

I'm not sure i understand you 100%. Let me try and explain my problem again.

I have a group of

1 Circle
1 Square
1 Line
1 Text

The group is called Sheet.8, and how a Custom property called "Show"

No i write in the shape sheet for every shape in the group

Circle: Geometry1.NoShow: =Not(Sheet.8!Prop.Show)
Squa Geometry1.NoShow: =Not(Sheet.8!Prop.Show)
Line: Geometry1.NoShow: =Not(Sheet.8!Prop.Show)
Text: HideText: =Not(Sheet.8!Prop.Show)

This i have 2 do for every shape in my group. If i got maby 20 shapes in the group, thats a lot of work.

I was wondering if there was a easy way, to hide all text and geometry in a group.

Blackend


"Chris Roth [ Visio MVP ]" wrote:

Are you setting Geometry1.NoShow = True to go invisible?

A nice technique is to use formula referencing, after adding a user cell:

User.Hide = True
Geometry1.NoShow = User.Hide
Geometry2.NoShow = User.Hide
Geometry3.NoShow = User.Hide
....

Or, you can turn off the line and fill patterns:

User.Hide = 0 or 1
FillPattern = Guard(User.Hide)
LinePattern = Guard(User.Hide)

Using Guard will keep the user from destroying your smarts by applying line
and fill formatting from the dialogs and toolbars.

--

Hope this helps,

Chris Roth
Visio MVP


"Blackend" wrote in message
...
Howcome when i add the geometry table, and set the Geometry1.NoShow the

spaes are not hidden - they stay visible.
Is there another way for doing this (all shapes with one setting) ? -

except hiding every shape in the group



  #5  
Old June 28th, 2004, 08:46 PM
Blackend
external usenet poster
 
Posts: n/a
Default Hide all shapes in a group

Hi Chris

I'm not sure i understand you 100%. Let me try and explain my problem in details

I have a group of:
1 Circle
1 Line
1 Text

The group is called Sheet.8, and has a custom property called "Show"

Now for every shape in the group i have to write the following code

Circle: Geometry1.NoShow: =NOT(Sheet.8!Prop.Show)
Line: Geometry1.NoShow: =NOT(Sheet.8!Prop.Show)
Text: HideText: = NOT(Sheet.8!Prop.Show)

If i got 20 shapes in my group - that's a lot of work. I was wondering if there was a more simple way of doing it.

Blackend

"Chris Roth [ Visio MVP ]" wrote:

Are you setting Geometry1.NoShow = True to go invisible?

A nice technique is to use formula referencing, after adding a user cell:

User.Hide = True
Geometry1.NoShow = User.Hide
Geometry2.NoShow = User.Hide
Geometry3.NoShow = User.Hide
....

Or, you can turn off the line and fill patterns:

User.Hide = 0 or 1
FillPattern = Guard(User.Hide)
LinePattern = Guard(User.Hide)

Using Guard will keep the user from destroying your smarts by applying line
and fill formatting from the dialogs and toolbars.

--

Hope this helps,

Chris Roth
Visio MVP


"Blackend" wrote in message
...
Howcome when i add the geometry table, and set the Geometry1.NoShow the

spaes are not hidden - they stay visible.
Is there another way for doing this (all shapes with one setting) ? -

except hiding every shape in the group



  #6  
Old June 28th, 2004, 08:47 PM
Blackend
external usenet poster
 
Posts: n/a
Default Hide all shapes in a group

Hi Chris

I'm not sure i understand you 100%. Let me try and explain my problem in details

I have a group of:
1 Circle
1 Line
1 Text

The group is called Sheet.8, and has a custom property called "Show"

Now for every shape in the group i have to write the following code

Circle: Geometry1.NoShow: =NOT(Sheet.8!Prop.Show)
Line: Geometry1.NoShow: =NOT(Sheet.8!Prop.Show)
Text: HideText: = NOT(Sheet.8!Prop.Show)

If i got 20 shapes in my group - that's a lot of work. I was wondering if there was a more simple way of doing it.

Blackend



"Chris Roth [ Visio MVP ]" wrote:

Are you setting Geometry1.NoShow = True to go invisible?

A nice technique is to use formula referencing, after adding a user cell:

User.Hide = True
Geometry1.NoShow = User.Hide
Geometry2.NoShow = User.Hide
Geometry3.NoShow = User.Hide
....

Or, you can turn off the line and fill patterns:

User.Hide = 0 or 1
FillPattern = Guard(User.Hide)
LinePattern = Guard(User.Hide)

Using Guard will keep the user from destroying your smarts by applying line
and fill formatting from the dialogs and toolbars.

--

Hope this helps,

Chris Roth
Visio MVP


"Blackend" wrote in message
...
Howcome when i add the geometry table, and set the Geometry1.NoShow the

spaes are not hidden - they stay visible.
Is there another way for doing this (all shapes with one setting) ? -

except hiding every shape in the group



  #7  
Old June 28th, 2004, 08:49 PM
Blackend
external usenet poster
 
Posts: n/a
Default Hide all shapes in a group

Sorry for the 3 same post - the site was giving me trouble

"Blackend" wrote:

Hi Chris

I'm not sure i understand you 100%. Let me try and explain my problem in details

I have a group of:
1 Circle
1 Line
1 Text

The group is called Sheet.8, and has a custom property called "Show"

Now for every shape in the group i have to write the following code

Circle: Geometry1.NoShow: =NOT(Sheet.8!Prop.Show)
Line: Geometry1.NoShow: =NOT(Sheet.8!Prop.Show)
Text: HideText: = NOT(Sheet.8!Prop.Show)

If i got 20 shapes in my group - that's a lot of work. I was wondering if there was a more simple way of doing it.

Blackend



"Chris Roth [ Visio MVP ]" wrote:

Are you setting Geometry1.NoShow = True to go invisible?

A nice technique is to use formula referencing, after adding a user cell:

User.Hide = True
Geometry1.NoShow = User.Hide
Geometry2.NoShow = User.Hide
Geometry3.NoShow = User.Hide
....

Or, you can turn off the line and fill patterns:

User.Hide = 0 or 1
FillPattern = Guard(User.Hide)
LinePattern = Guard(User.Hide)

Using Guard will keep the user from destroying your smarts by applying line
and fill formatting from the dialogs and toolbars.

--

Hope this helps,

Chris Roth
Visio MVP


"Blackend" wrote in message
...
Howcome when i add the geometry table, and set the Geometry1.NoShow the

spaes are not hidden - they stay visible.
Is there another way for doing this (all shapes with one setting) ? -

except hiding every shape in the group



  #8  
Old June 29th, 2004, 09:33 AM
Chris Roth [ Visio MVP ]
external usenet poster
 
Posts: n/a
Default Hide all shapes in a group

Open the VBA window, paste and run this code:

Sub DoIt

' Get selected shape:
dim shp as visio.shape, sub as visio.shape
set shp = ActiveWindow.Selection(1)

' Build formula:
dim f as string
f = "NOT(Sheet.XXX!Prop.Show)"
f = Replace( f, "XXX", shp.ID)

' Apply to each sub-shape:
for each sub in shp.shapes
sub.Cells("Geometry1.NoShow").FormulaForce = f
sub.Cells("HideText").FormulaForce = f
next

End Sub

--

Hope this helps,

Chris Roth
Visio MVP


"Blackend" wrote in message
...
Sorry for the 3 same post - the site was giving me trouble

"Blackend" wrote:

Hi Chris

I'm not sure i understand you 100%. Let me try and explain my problem in

details

I have a group of:
1 Circle
1 Line
1 Text

The group is called Sheet.8, and has a custom property called "Show"

Now for every shape in the group i have to write the following code

Circle: Geometry1.NoShow: =NOT(Sheet.8!Prop.Show)
Line: Geometry1.NoShow: =NOT(Sheet.8!Prop.Show)
Text: HideText: = NOT(Sheet.8!Prop.Show)

If i got 20 shapes in my group - that's a lot of work. I was wondering

if there was a more simple way of doing it.

Blackend



"Chris Roth [ Visio MVP ]" wrote:

Are you setting Geometry1.NoShow = True to go invisible?

A nice technique is to use formula referencing, after adding a user

cell:

User.Hide = True
Geometry1.NoShow = User.Hide
Geometry2.NoShow = User.Hide
Geometry3.NoShow = User.Hide
....

Or, you can turn off the line and fill patterns:

User.Hide = 0 or 1
FillPattern = Guard(User.Hide)
LinePattern = Guard(User.Hide)

Using Guard will keep the user from destroying your smarts by applying

line
and fill formatting from the dialogs and toolbars.

--

Hope this helps,

Chris Roth
Visio MVP


"Blackend" wrote in message
...
Howcome when i add the geometry table, and set the Geometry1.NoShow

the
spaes are not hidden - they stay visible.
Is there another way for doing this (all shapes with one setting)

? -
except hiding every shape in the group





  #9  
Old June 29th, 2004, 06:15 PM
Blackend
external usenet poster
 
Posts: n/a
Default Hide all shapes in a group

Hi Chris

Yeps - This solves my problems.

I would like to put the code on my Group/shape so everytime i change the custom property "Show" i run this macro

I that possible ?

Blackend

"Chris Roth [ Visio MVP ]" wrote:

Open the VBA window, paste and run this code:

Sub DoIt

' Get selected shape:
dim shp as visio.shape, sub as visio.shape
set shp = ActiveWindow.Selection(1)

' Build formula:
dim f as string
f = "NOT(Sheet.XXX!Prop.Show)"
f = Replace( f, "XXX", shp.ID)

' Apply to each sub-shape:
for each sub in shp.shapes
sub.Cells("Geometry1.NoShow").FormulaForce = f
sub.Cells("HideText").FormulaForce = f
next

End Sub

--

Hope this helps,

Chris Roth
Visio MVP


"Blackend" wrote in message
...
Sorry for the 3 same post - the site was giving me trouble

"Blackend" wrote:

Hi Chris

I'm not sure i understand you 100%. Let me try and explain my problem in

details

I have a group of:
1 Circle
1 Line
1 Text

The group is called Sheet.8, and has a custom property called "Show"

Now for every shape in the group i have to write the following code

Circle: Geometry1.NoShow: =NOT(Sheet.8!Prop.Show)
Line: Geometry1.NoShow: =NOT(Sheet.8!Prop.Show)
Text: HideText: = NOT(Sheet.8!Prop.Show)

If i got 20 shapes in my group - that's a lot of work. I was wondering

if there was a more simple way of doing it.

Blackend



"Chris Roth [ Visio MVP ]" wrote:

Are you setting Geometry1.NoShow = True to go invisible?

A nice technique is to use formula referencing, after adding a user

cell:

User.Hide = True
Geometry1.NoShow = User.Hide
Geometry2.NoShow = User.Hide
Geometry3.NoShow = User.Hide
....

Or, you can turn off the line and fill patterns:

User.Hide = 0 or 1
FillPattern = Guard(User.Hide)
LinePattern = Guard(User.Hide)

Using Guard will keep the user from destroying your smarts by applying

line
and fill formatting from the dialogs and toolbars.

--

Hope this helps,

Chris Roth
Visio MVP


"Blackend" wrote in message
...
Howcome when i add the geometry table, and set the Geometry1.NoShow

the
spaes are not hidden - they stay visible.
Is there another way for doing this (all shapes with one setting)

? -
except hiding every shape in the group






  #10  
Old June 30th, 2004, 10:48 AM
Chris Roth [ Visio MVP ]
external usenet poster
 
Posts: n/a
Default Hide all shapes in a group

If you're using VBA, try the following:

Add a user cell like this:

User.Trigger = DependsOn(Prop.Show) + CallThis( "ThisDocument.DoIt" )

Change your sub so that it has a shape argument:

Sub DoIt( shp as Visio.shape)
...
End Sub

Remember to get rid of the shp declaration *inside* of the sub!

--

Hope this helps,

Chris Roth
Visio MVP


"Blackend" wrote in message
...
Hi Chris

Yeps - This solves my problems.

I would like to put the code on my Group/shape so everytime i change the

custom property "Show" i run this macro

I that possible ?

Blackend

"Chris Roth [ Visio MVP ]" wrote:

Open the VBA window, paste and run this code:

Sub DoIt

' Get selected shape:
dim shp as visio.shape, sub as visio.shape
set shp = ActiveWindow.Selection(1)

' Build formula:
dim f as string
f = "NOT(Sheet.XXX!Prop.Show)"
f = Replace( f, "XXX", shp.ID)

' Apply to each sub-shape:
for each sub in shp.shapes
sub.Cells("Geometry1.NoShow").FormulaForce = f
sub.Cells("HideText").FormulaForce = f
next

End Sub

--

Hope this helps,

Chris Roth
Visio MVP


"Blackend" wrote in message
...
Sorry for the 3 same post - the site was giving me trouble

"Blackend" wrote:

Hi Chris

I'm not sure i understand you 100%. Let me try and explain my

problem in
details

I have a group of:
1 Circle
1 Line
1 Text

The group is called Sheet.8, and has a custom property called "Show"

Now for every shape in the group i have to write the following code

Circle: Geometry1.NoShow: =NOT(Sheet.8!Prop.Show)
Line: Geometry1.NoShow: =NOT(Sheet.8!Prop.Show)
Text: HideText: = NOT(Sheet.8!Prop.Show)

If i got 20 shapes in my group - that's a lot of work. I was

wondering
if there was a more simple way of doing it.

Blackend



"Chris Roth [ Visio MVP ]" wrote:

Are you setting Geometry1.NoShow = True to go invisible?

A nice technique is to use formula referencing, after adding a

user
cell:

User.Hide = True
Geometry1.NoShow = User.Hide
Geometry2.NoShow = User.Hide
Geometry3.NoShow = User.Hide
....

Or, you can turn off the line and fill patterns:

User.Hide = 0 or 1
FillPattern = Guard(User.Hide)
LinePattern = Guard(User.Hide)

Using Guard will keep the user from destroying your smarts by

applying
line
and fill formatting from the dialogs and toolbars.

--

Hope this helps,

Chris Roth
Visio MVP


"Blackend" wrote in message
...
Howcome when i add the geometry table, and set the

Geometry1.NoShow
the
spaes are not hidden - they stay visible.
Is there another way for doing this (all shapes with one

setting)
? -
except hiding every shape in the group








 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Sending Email To A Group Ron Sommer Outlook Express 4 August 28th, 2004 03:33 AM
Supress email addresses when sending group emails? munkeyscare General Discussion 1 June 22nd, 2004 03:52 PM
Help Needed for Groups Please Paul Black General Discussion 15 June 21st, 2004 02:54 AM
Group page numbering Leslie Isaacs Setting Up & Running Reports 4 May 28th, 2004 12:58 PM


All times are GMT +1. The time now is 11:04 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.