TM1 Forum

HI Team ,

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

Please help your inputs

Moved to the correct forum.

Thanks for reply

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

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

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

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.

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.

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

How does his restrict the input of negative values ?

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...

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

Thanks all for your reply