Video How to Post a nice screen-shot with Mr.Excel HTML Maker

[GerryZ]

hello if you like to post in your threads a nice HTML screen-shot like this
whatch this YOUTUBE video and I'll show you how to Istall the ADD-IN and how to use it
https://www.youtube.com/watch?v=JycvgGppxt0&feature=youtu.be
let me know!

Book1
	A	B	C	D	E	F	G	H	I
1		JAN	FEB	MAR	APR	MAY		41	criterio
2	Frank	11	17	30	10	9		Julia	riga
3	Joe	28	22	34	22	43		JAN	colonna
4	Anna	5	22	14	37	21
5	Julia	12	18	19	35	20
6	Anna	24	34	9	37	12
7	Julia	41	36	39	20	23
8	Anna	99	8	5	31	32
9	Frank	35	24	42	24	36
2

Cell Formulas
Range	Formula
H2	{=IF(COUNTIF($B$2:$F$9,H$1)=1,INDEX($A$2:$A$9,MIN(IF($B$2:$F$9=H$1,ROW($A$2:$A$9)-ROW($A$2)+1))),"")}
H3	{=IF(H2="","",INDEX($B$1:$F$1,MIN(IF($A$2:$A$9=$H$2,IF($B$2:$F$9=$H$1,COLUMN($B$1:$F$1)-COLUMN($B$1)+1)))))}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Caribeiro77]

Grazie...

 

[Rick Rothstein]

Hello every body
I'm glad you like this video
it would be interesting if many of us put the link of this video on the signature so as to disclose as much as possible
thank so much

I liked your video also... great job! And I added a link to your video in my signature line as well.

 

[GerryZ]

@Rick
One of yours ( I LIKED) worth double
thank you!

 

[Rick Rothstein]

@Rick
One of yours ( I LIKED) worth double
thank you!

That is very kind of you to say. If it is not too hard to add on to your video, I thought of one thing that you could put in it at the end... explain that, by default, the add-in will display three modules (code windows) every time the VBA editor is opened and that to stop it (you should show these next steps in your video), simply "Lock project for viewing", assign a password and (this is important) "Save HtmlMaker20101230.xla" from the VBA editor's File menu item to lock in the changes.

 

[AkaTrouble]

i stole both links from rick's signature and added to mine

good video will help help many

 

[Caribeiro77]

Hey Rick in your post #14 you said

"the add-in will display three modules (code windows) every time the <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> editor is opened"

However after install the add in 5 have 6 modules instead of 3 as you said...

[/URL][/IMG]

Is this normal?

 

[Rick Rothstein]

Hey Rick in your post #14 you said

"the add-in will display three modules (code windows) every time the <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> editor is opened"

However after install the add in 5 have 6 modules instead of 3 as you said...

[/URL][/IMG]

Is this normal?

No, you are right, there are 6 modules, but (I think, not sure now) only 3 were fully opened showing their actual code... until I locked the project's view, these kept displaying and I had to manually close each one (so they did not clutter up area where modules are displayed.

 

[GerryZ]

i stole both links from rick's signature and added to mine

good video will help help many

Thank you AkaTrauble
waiting to see your first HTML screen-shot
bye

 

[GerryZ]

That is very kind of you to say. If it is not too hard to add on to your video, I thought of one thing that you could put in it at the end... explain that, by default, the add-in will display three modules (code windows) every time the VBA editor is opened and that to stop it (you should show these next steps in your video), simply "Lock project for viewing", assign a password and (this is important) "Save HtmlMaker20101230.xla" from the VBA editor's File menu item to lock in the changes.

hello Rick
It's not difficult to add something in the end of the video but
My VBA knowledge is very poor so I would not know how to complement HTML maker wih VBA
Let's leave it like this maybe one day...
ciao

 

[advent]

Hi Gerry dear sir;
I followed everything as per your instructions but find I have a little problem!!!!
I highlight the section of excel worksheet, click on the MrExcel HTML tag on my ribbon, select the first cell in each option tag and immediately receive an error message:
Run Time error '53', File not found: user 32dll ???

I was wondering if its because I am using a MacBook Air, any ideas?

Regards

David