blue "CREATE" button, the macro executes and
creates the chart. How did you do that?
3
How to add a title to the chart, say "trend over time"?
Sorry for so many further questions, thank you so much for your time
and help again!!!
Jerry
On Jun 22, 1:25 am, ashish koul wrote:
ss of the cell which contains the
value of "starting year month", and replace f49 with the address of the cell
that's 3 columns to the right of the cell which contains the value of
"ending year month", I will be getting very closer to my goal.
Any help is highly appreciate
I now realise I'd like to prevent the deletion of selected sheets as
well. I cannot see any event which I could trap which would prevent a
user from deleting a sheet. Any ideas?
On Jun 7, 2:22 am, sudhi na wrote:
> dear Harpreet & Jerry,
>
> here is file in which you cannot
Thanks, Harry. I'll have a look into that. Actually I've discovered
that if you protect the workbook, renaming of the sheets becomes
disabled.
On Jun 6, 6:13 am, Harpreet Singh Gujral
wrote:
> Jerry,
>
> Two ways, if adopted can help protect the sheet the way you want to:
&g
The answer to this question is to add an _Exit procedure.
Updated file to show the solution is available at
http://www.mediafire.com/file/wjkmmrzlkwm/FormTestExampleUpdated.xlsm
On Jun 4, 10:45 pm, Jerry wrote:
> I have a textbox the content of which I need to validate once the user
&g
The subject says it all. I want to prevent the user from renaming a
couple of worksheets in a workbook but I do not want to prevent the
user from modifying the data on the worksheet.
--
--
Some important links for exc
I have a textbox the content of which I need to validate once the user
has updated it in the _AfterUpdate event.If a character is invalid, I
highlight it and display an error message in a label control. E.G.
tbInput.SelStart = i - 1
tbInput.SelLength = 1
and try to give it the focus:
