Re: Macro starts if value in cell c20 = OK
hi,
thanks for your reply but I do not understand.
sorry
kind regards,
Re: Macro starts if value in cell c20 = OK
hi,
thanks for your reply but I do not understand.
sorry
kind regards,
hi there,
Is there a way to make cells change color if one of them is clicked?
For example I would like to meke cells a1:h1 change color if one of cells is clicked.
greetings to all and many thanks for help
hi everyone,
I am not expert in vba, much better in excel. Please let me know how to make a macro (previously recorded) starts at specific moment - exactly when in one cell (for example c20) the "OK" text will be displayed. "OK" will only appear at specified moment (in my example 8:45am) in only working days.
many thankt and very best to all community
Marcin
Re: Comment not to cell but comment to value of a cell
hi there,
Thanks for your advices but I have a problem implementing that.
Do I have to add comment to that cell and then record new macro - you've adviced me, and attache (how - if) that macro to comment "cloud"?
I am not very familiar with VBA and that is possible reason why it sometimes seams to me difficult.
I want set a cells (f.e. worksheet 3, cell AB13:AB113) as a cell that will be a source for comment cloud. And I want to set a comment clouds (f.e. attached to worksheet 1 cell A3:A103). If the cell f.e. A5 in worksheet 1 will display data from worksheet 3 X54 then he comment cloud attached to that cell (A5) will display what is stored in cell AB15. If the cell A5 will display data from cell X100 then comment cloud will display data from cell AB100.
Please correct me if I am wrong (first part)
I have attached more explanation (second part) - if there were not neccessary - please forgive
best regards, to all comunity
marcino
Hi Everyone,
I am still working on a worhsheet that displays different texts and values dependant to calculations in several of sheets.
One of problems I am facing is to display many informations on not very big area. My idea is to attach a comment that will display informations stored in other sheet. But comment has to be attached not to a cell but to the text or value of that cell. It is because the cells shows the effect of INDIRECT(ADDRESS(...)). I would like that comment to display data accordingly to what is displayed in cell.
Can anyone help or let me know that it is completely not possible to do .
Thanks in advance
:thanx:
Re: Add a calendar to right click
Hi RoyUK,
I was looking at your addin - as said previously it is amazing. But there is one mor thing - when it starts it always shows - as a startup month - march 2005. I am totally not familiar with building up an addins and therefore I cannot help (but I definetelly would like to...).
best regards to all OZGRID community
Re: Add a calendar to right click
Hi RoyUK,
it is amazing!!
hats off!!
I am trying to implement it in my worksheet. Previously I was using a combo box with reference to list of upcoming days but was thinking about calendar like form.
Please let me know if there is a possibility to use it in a quicker way? I mean to set a specified cell and if you press right mouse button over that cell it automatically display calendar form. Not right click, then "Add Date to Cell".
I think it will help other users to use your addin in my spreadsheet even without knowledge of how to use it.
best regards and nice weekend
thanks for all your help in past and in future :thanx:
Re: Increase password strength
yes I know
and that is the way I am going to work - second advice for macros, first to protect worksheet and hide all formulas.
thanks for your help
:thanx:
Re: Increase password strength
thanks
but it will work only on macros I guess.
I am working on your previous advice - userform
rgds,
and thanks
Re: Increase password strength
OK,
I am a begginer to your forum - that might be an explanation.
I will not again
rgds,
Re: chart with self changing colors
hi
thanks
it is just a one value - not a series. that value is changing continously (almost). I put a small chart (that is changing colors) in my spreadsheet and it is not neccessery to have shaded colors. Maybe later I will try to work with "IF" formula to use "2 series" solution
thanks VM
:thanx:
Re: macro that starts a proces at specified date
hi there,
Many thanks for your help - as I said previously I am not an expert but I will try to use your advices to implement my ideas.
I'll let you know
THANKS
:thanx:
Re: password in excl
hi there,
thanks for your help.
I am not an expert but I will try use your advices. will let you know if it works.
THANKX FOR HELP
:thanx:
Re: chart with selfchanging colors
hi
thanks for your help.
It is working but only with single colors, if you want to use shading colors it is a bit complicated.
Thanks for help :thanx:
hi
is there any way to put a chart (bar) that shows a value but uses different colors of bar for bigger and less than zero.
can anyone help please?
marcin
hi
I am trying to produce a macro that will act at specified date of time. For example feb 28th delete all formula cells. Or mar 3rd copy value of cells... to cells....
Please can anyone help
Wondering if there's a much safer password than built-in microsoft password.
I would like to use password and let other users of my spreadsheet. but password will avoid other users from looking at my formulas and macros. As I know microsoft password is very easily to crack.
Can anyone help please