Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-18-2012, 02:57 PM
excelledsoftware excelledsoftware is offline Hide Objects in 2003 Windows 7 64bit Hide Objects in 2003 Office 2003
IT Specialist
Hide Objects in 2003
 
Join Date: Jan 2012
Location: Utah
Posts: 455
excelledsoftware will become famous soon enough
Default Hide Objects in 2003

There is an awesome feature in PPT 2010 that lets you hide certain objects when working with shapes. This feature is not available in 2003 but there are many other features not available in 2010 that I use in 2003. So my question is this.



Could we possibly recreate the hide feature with a macro. I was thinking that after the user has selected all objects the macro could record the size and position on the slide and then it could shrink them down and pull them off of the slide temporarily. Once the user is done editing the macro would be able to take the hidden objects back to the original recorded size and then to the original position on the slide.

I really dont know enough about VBA to make this work and it would most likely require 2 macros 1 to record the size, position, and move them off the slide. And another to put them back with the original size and position.

Any ideas?
Reply With Quote
  #2  
Old 01-18-2012, 03:35 PM
JohnWilson JohnWilson is offline Hide Objects in 2003 Windows 7 64bit Hide Objects in 2003 Office 2010 32bit
Programmer
 
Join Date: Nov 2008
Location: UK
Posts: 1,912
JohnWilson has a spectacular aura aboutJohnWilson has a spectacular aura about
Default

There's no need to resize. Just set the visible property to false (or True to show again)

eg

ActivePresentation.Slides(1).Shapes(3).Visible=Fal se
__________________
Microsoft PowerPoint MVP 2007-2023
Free Advanced PowerPoint Tips and Tutorials
Reply With Quote
  #3  
Old 01-18-2012, 06:16 PM
excelledsoftware excelledsoftware is offline Hide Objects in 2003 Windows 7 64bit Hide Objects in 2003 Office 2003
IT Specialist
Hide Objects in 2003
 
Join Date: Jan 2012
Location: Utah
Posts: 455
excelledsoftware will become famous soon enough
Default

Quote:
Originally Posted by JohnWilson View Post
There's no need to resize. Just set the visible property to false (or True to show again)

eg

ActivePresentation.Slides(1).Shapes(3).Visible=Fal se

Thanks
This is pretty awesome since I had no idea it would be this easy. Only problem is it is just working with 1 auto shape. I tried changing the code to selection and it still only lets me hide 1 shape at a time. Any thoughts?
Reply With Quote
  #4  
Old 01-18-2012, 06:21 PM
excelledsoftware excelledsoftware is offline Hide Objects in 2003 Windows 7 64bit Hide Objects in 2003 Office 2003
IT Specialist
Hide Objects in 2003
 
Join Date: Jan 2012
Location: Utah
Posts: 455
excelledsoftware will become famous soon enough
Default

Got it. I just needed a little help from good ol John Wilson.

Here is what works. Incredible Ive never been so happy to have these tools available

Sub hide()
ActiveWindow.Selection.ShapeRange.Visible = False

End Sub

Sub unhide()
ActiveWindow.Selection.ShapeRange.Visible = true

End Sub
Reply With Quote
  #5  
Old 01-19-2012, 01:46 AM
JohnWilson JohnWilson is offline Hide Objects in 2003 Windows 7 64bit Hide Objects in 2003 Office 2010 32bit
Programmer
 
Join Date: Nov 2008
Location: UK
Posts: 1,912
JohnWilson has a spectacular aura aboutJohnWilson has a spectacular aura about
Default

We are actually working on a "Selection Pane" AddIn for 2003 at the moment. It will create a list of all shapes on the slide and allow you to hide / show instantly by checking a check box and rename them. If you would like to be a tester drop me a line (go to PPTAlchemy and use the contact page.)

Should be out for testing in a couple of weeks.
__________________
Microsoft PowerPoint MVP 2007-2023
Free Advanced PowerPoint Tips and Tutorials

Last edited by JohnWilson; 01-19-2012 at 06:04 AM.
Reply With Quote
  #6  
Old 01-25-2012, 12:01 AM
excelledsoftware excelledsoftware is offline Hide Objects in 2003 Windows 7 64bit Hide Objects in 2003 Office 2003
IT Specialist
Hide Objects in 2003
 
Join Date: Jan 2012
Location: Utah
Posts: 455
excelledsoftware will become famous soon enough
Default

Quote:
Originally Posted by JohnWilson View Post
We are actually working on a "Selection Pane" AddIn for 2003 at the moment. It will create a list of all shapes on the slide and allow you to hide / show instantly by checking a check box and rename them. If you would like to be a tester drop me a line (go to PPTAlchemy and use the contact page.)

Should be out for testing in a couple of weeks.
what code would I use to unhide all of the shapes that I hid. I tried

ActiveWindow.Selection.SlideRange.Shapes.SelectAll
ActiveWindow.Selection.ShapeRange.visible=true

but it keeps on hating the select all command.
Reply With Quote
  #7  
Old 01-25-2012, 01:09 AM
JohnWilson JohnWilson is offline Hide Objects in 2003 Windows 7 64bit Hide Objects in 2003 Office 2010 32bit
Programmer
 
Join Date: Nov 2008
Location: UK
Posts: 1,912
JohnWilson has a spectacular aura aboutJohnWilson has a spectacular aura about
Default

Dim osld As Slide
Set osld = ActivePresentation.Slides(1)'or whatever
osld.Shapes.Range.Visible = False
__________________
Microsoft PowerPoint MVP 2007-2023
Free Advanced PowerPoint Tips and Tutorials
Reply With Quote
  #8  
Old 01-25-2012, 02:59 PM
excelledsoftware excelledsoftware is offline Hide Objects in 2003 Windows 7 64bit Hide Objects in 2003 Office 2003
IT Specialist
Hide Objects in 2003
 
Join Date: Jan 2012
Location: Utah
Posts: 455
excelledsoftware will become famous soon enough
Default

Quote:
Originally Posted by JohnWilson View Post
Dim osld As Slide
Set osld = ActivePresentation.Slides(1)'or whatever
osld.Shapes.Range.Visible = False

Thanks again John,

How do I get this code to work for the current slide?
Reply With Quote
  #9  
Old 01-29-2012, 11:26 AM
excelledsoftware excelledsoftware is offline Hide Objects in 2003 Windows 7 64bit Hide Objects in 2003 Office 2003
IT Specialist
Hide Objects in 2003
 
Join Date: Jan 2012
Location: Utah
Posts: 455
excelledsoftware will become famous soon enough
Default

Quote:
Originally Posted by excelledsoftware View Post
Thanks again John,

How do I get this code to work for the current slide?
Nevermind I got it to work. Much more simple than I thought

Sub unhide()
ActiveWindow.Selection.SlideRange.Shapes.SelectAll
With ActiveWindow.Selection.ShapeRange
.Visible = msoTrue
End With
ActiveWindow.Selection.Unselect
End Sub

Thanks again John
Reply With Quote
  #10  
Old 01-29-2012, 12:11 PM
JohnWilson JohnWilson is offline Hide Objects in 2003 Windows 7 64bit Hide Objects in 2003 Office 2010 32bit
Programmer
 
Join Date: Nov 2008
Location: UK
Posts: 1,912
JohnWilson has a spectacular aura aboutJohnWilson has a spectacular aura about
Default

Glad you got it working.

I always try to avoid selection

Sub show_all()
Dim osld As Slide
For Each osld In ActivePresentation.Slides
osld.Shapes.Range.Visible = True
Next
End Sub
__________________
Microsoft PowerPoint MVP 2007-2023
Free Advanced PowerPoint Tips and Tutorials
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't move objects with precision MLF PowerPoint 3 07-31-2014 04:03 AM
Hide Objects in 2003 Can't Shift Objects Off Sheet - What is that? namedujour Excel 5 05-13-2011 06:30 AM
Hide Objects in 2003 Shape Objects Space Cowboy PowerPoint 4 10-04-2010 07:14 PM
NOprintable objects shadowbat Drawing and Graphics 0 07-05-2010 10:13 PM
Hide Objects in 2003 Unhide and Re-hide in Excel 2003 thorgal67 Excel 1 07-16-2009 07:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:42 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft