Visibility of object without VBA

[J]

Hi

XL98 / Windows 98

I'm trying to create an order form for my pottery company which can be
downloaded from my website.
I'd like the user to be able to see a picture of each pottery item as they
enter / highlight the row containing that item.

I have maybe 12 products to display and was thinking of layering 12 small
pictures on top of each other ... with only the selected item being visible.

This would be easy in VBA, but I don't want to use macros (nobody would open
the order form!). Does any know of any way I can set the visibility to true
or false (or perhaps the height to zero or 50 ) or another clever function
or method to achieve this result?

Many thanks
John

 

[Frank Kabel]

Hi
don't think this is possible without using VBA

 

[Tushar Mehta]

Rather than create an XL-based form that people download from your web
site, why don't you create a web-based ordering form?

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2004

 

[John]

Thanks Tushar

The main reason is I know a bit of XL but next to nothing about the web ( I
got a friend to put up my one-page website) .... the form needs to calculate
prices, delivery charges and options based on quantities and prices. Is this
something I can do in XL and 'upload' ?

Rgds
John

 

[Tushar Mehta]

I'm sorry but you are trying to fit a square peg into a round hole.

XL is not meant for use as a web interface. You need to look at
JavaScript and/or PHP and/or ASP and/or ???

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions