how to restrict user input using macros in Excelladdin

ranga · Post by **ranga** » Fri Dec 11, 2015 3:41 am

HI Team ,

i want restrict user input negative value into excel template using macros .

Please help your inputs

jim wood · Post by **jim wood** » Fri Dec 11, 2015 1:39 pm

Moved to the correct forum.

ranga · Post by **ranga** » Tue Dec 15, 2015 4:26 am

Thanks for reply

i am new to this portal . please tell me which group we can keep this post

Wim Gielis · Post by **Wim Gielis** » Tue Dec 15, 2015 7:19 am

This subforum is fine, Jim moved the topic for you.

RJ! · Post by **RJ!** » Tue Dec 15, 2015 7:53 am

ranga wrote:HI Team ,
i want restrict user input negative value into excel template using macros .

If I'm reading that right, I think you need to have code against an "On Change" procedure in your Excel Template that monitors the cells your looking at...

Though if it was me, I'd just use Data Validation in Excel to restrict a user from inputting anything "Less then 0" in your form

Wim Gielis · Post by **Wim Gielis** » Wed Dec 16, 2015 2:06 pm

The event in VBA is called Worksheet_Change event.
You will find thousands of code samples on the internet with a search action.
However, as said above, there are better ways to tackle this requirement.

jduplessis · Post by **jduplessis** » Wed Dec 16, 2015 2:44 pm

Another alternative is using sell locking and protecting the sheet. We use this a lot because it also works in TM1 web, unlike VBA alternatives.

Wim Gielis · Post by **Wim Gielis** » Wed Dec 16, 2015 3:00 pm

jduplessis wrote:Another alternative is using sell locking and protecting the sheet

How does his restrict the input of negative values ?

jduplessis · Post by **jduplessis** » Wed Dec 16, 2015 3:07 pm

Wim Gielis wrote:
jduplessis wrote:Another alternative is using sell locking and protecting the sheet
How does his restrict the input of negative values ?

Ah, I stopped reading at restrict values... technically I suppose not being able to enter any value would include not being able to enter negative values, but not the intended outcome...

Wim Gielis · Post by **Wim Gielis** » Wed Dec 16, 2015 3:40 pm

jduplessis wrote:
Wim Gielis wrote:
jduplessis wrote:Another alternative is using sell locking and protecting the sheet
How does his restrict the input of negative values ?
Ah, I stopped reading at restrict values... technically I suppose not being able to enter any value would include not being able to enter negative values, but not the intended outcome...

Let's give READ access to everyone and we will never ever suffer from bad input

ranga · Post by **ranga** » Wed Dec 23, 2015 2:05 pm

Thanks all for your reply

TM1 Forum

how to restrict user input using macros in Excelladdin

how to restrict user input using macros in Excelladdin

Re: how to restrict user input using macros in Excelladdin

Re: how to restrict user input using macros in Excelladdin

Re: how to restrict user input using macros in Excelladdin

Re: how to restrict user input using macros in Excelladdin

Re: how to restrict user input using macros in Excelladdin

Re: how to restrict user input using macros in Excelladdin

Re: how to restrict user input using macros in Excelladdin

Re: how to restrict user input using macros in Excelladdin

Re: how to restrict user input using macros in Excelladdin

Re: how to restrict user input using macros in Excelladdin